Release 10.1A: OpenEdge Data Management:
Database Administration

PROSTRCT ADD and pathnames

When you use PROSTRCT ADD to add additional storage areas or extents to a relative path database, the relative path database is converted to an absolute path database. For example, if you add an additional application data storage area named Misc to the relative path database example1, PROSTRCT ADD converts the relative path database to an absolute path database. Use PROSTRCT LIST to update the .st file with the added extents. For example:

prostrct add example1 add.st prostrct list example1

In the following sample output of the PROSTRCT LIST utility, note the absolute pathname (/usr1/example1.db) of the modified database:

Area Name: Control Area, Type6, BlockSize 4096, Extents 1, Records/Block32, Cluster Size 1    Ext # 1, Type VARIABLE, Size 0, Name: /usr1/example1.db Area Name: Primary Recovery Area, Type3, BlockSize 8192, Extents 1    Ext # 1, Type VARIABLE, Size 0, Name: /usr1/example1.b1 Area Name: Schema Area, Type6, BlockSize 4096, Extents 1, Records/Block 32, Cluster Size 1    Ext # 1, Type VARIABLE, Size 0, Name: /usr1/example1.d1 Area Name: Employee, Type6, BlockSize 1024, Extents 2, Records/Block 32, Cluster Size 8    Ext # 1, Type FIXED , Size 320, Name: /usr1/example1_7.d1    Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_7.d2 Area Name: Inventory, Type6, BlockSize 1024, Extents 2, Records/Block 32, Cluster Size 64    Ext # 1, Type FIXED , Size 608, Name: /usr1/cmcguire/example1_8.d1    Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_8.d2 Area Name: Cust_Data, Type6, BlockSize 1024, Extents 2, Records/Block 32, Cluster Size 64    Ext # 1, Type FIXED , Size 320, Name: /usr1/example1_9.d1    Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_9.d2 Area Name: Cust_Index, Type 6, BlockSize 1024, Extents 2, Records/Block 32    Ext # 1, Type FIXED , Size 320, Name: /usr1/example1_10.d1    Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_10.d2 Area Name: Order, Type6, BlockSize 1024, Extents 2, Records/Block 32, Cluster Size 64    Ext # 1, Type FIXED , Size 1280, Name: /usr1/example1_11.d1    Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_11.d2 Area Name: Misc, Type6, BlockSize 1024, Extents 2, Records/Block 32    Ext # 1, Type FIXED , Size 320, Name: /usr1/example1_12.d1    Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_12.d2